[Top] [Prev] [Next] [Bottom] [Contents]

Loops

A loop is a handy item to have in every programming language. Therefore, one has been added to the data population mechanism for Sapphire/Web:

##Sa_BeginLoop##
	...
##Sa_EndLoop##
By simply wrapping a block of HTML with this looping marker, that block will be repeated once for each row of data returned by the bound Data Object. Each Data Site contained in the looped block will be populated with the current data row's column value. Here are examples of addresses:

The Data Object of type DSQL looks like this:

SELECT lastname, firstname, address, city, state, zipcode 
FROM people
The HTML Block looks like this:

<PRE>
##Sa_BeginLoop##
##Sa_Lastname##, ##Sa_Firstname##
##Sa_Address##
##Sa_City##, ##Sa_State## ##Sa_Zipcode##
<BR>
##Sa_endLoop##
</PRE>
The output would look like this after the binding took place and was tested:

Pennell, Scott
P.O. Box IMB4U
Mt. Laurel, NJ 08054

Nigro, Mark
123 456th Street
Mt. Laurel, NJ 08054

Naugle, Bob
123 Penny Lane
Mt. Laurel, NJ 08054

Eakin, Wm. Joseph
54321 Countdown Blvd.
Mt. Laurel, NJ 08054

Bentz, Ray
abc 123
Mt. Laurel, NJ 08054

Gilson, Peg
P.O. Box 3.14
Mt. Laurel, NJ 08054


[Top] [Prev] [Next] [Bottom] [Contents]

info@bluestone.com
Copyright © 1997, Bluestone. All rights reserved.